package com.shangqing.system.mapper.geology;

import com.shangqing.common.core.domain.entity.geologic.GeologicHazard;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;

@Mapper
public interface GeologyMapper {
    /*倒序显示灾害信息，离当前时间最近的Num条信息*/
    public List<Map> findGeologyList(String Num);
    /*按照年份、季度查询每个季度的灾害个数*/
    /*按年份查 按季度，灾害类别查，年份没有，默认当年年份，季度没有，默认12个月，灾害类别没有，全部灾害类别*/
    public Integer findGeologyListByQuarter(@Param(value = "years") String year,
                                            @Param(value = "quarter")String quarter,
                                            @Param(value = "geologyType")String geologyType);
    /*区级灾害数*/
    /**/
    public Integer findCountGeologyByCity(@Param(value = "cityId") Integer cityId,
                                          @Param(value = "years") String years,
                                          @Param(value = "quarter")String quarter);
    /*全部灾害数*/
    /*按照年份、季度条件查出所有灾害数*/
    public Integer findAllCountGeology(@Param(value = "years") String years,
                                       @Param(value = "quarter")String quarter);
    /*各区灾情统计*/
    public List<Map> findRegionalDisasterStatistics(Integer cityId);




}
